package com.xhh.nphm.gaoxin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xhh.nphm.common.annotation.DataSource;
import com.xhh.nphm.common.constant.Constants;
import com.xhh.nphm.gaoxin.entity.GxqTwfJudgeEty;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository

public interface GxqTwfJudgeDao extends BaseMapper<GxqTwfJudgeEty> {
    @Select("select PkId,WfId,JudgeIP,convert(varchar(19),VisitTime,20) as visitTime,VisitPerson,VstDeptName,VstUserName,JudgeN,VstDesc,PkId as myOP from tWfJudge where WfId=#{wfId} and IsDel=0 order by PkId desc")
    List<Map<String,Object>> selectByWfId(Integer wfId);
}
